Ohio State navigation bar
John Glenn College of Public Affairs
Ohio Education Research Center
Isabelle Frohlich
The Ohio Education Research Center — a collaborative of the John Glenn College of Public Affairs and the CHRR — offers the Public Sector Data Science Internship Program for students interested in exploring careers in policy research and evaluation. This year, we were very excited to host three interns at state agencies across Columbus. Continue reading to learn more about the work they accomplished this summer. Our next intern of the week is Isabelle Frohlich. Isabelle is going into her second year of her Master of Arts in Public Policy and Management at the Glenn College. She interned with the Ohio Department of Jobs and Family Services (ODJFS) and used data from the Comprehensive Case Management and Employment Program to better understand how the program is performing and who it is serving. Her reflections on the internship are shared below: Hi, my name is Isabelle Frohlich and I’m going into my second year of my Master’s of Public Administration. I am working with the Ohio Department of Jobs and Family Services. I did the PSDS internship to expand my skills in the data science field and strengthen my knowledge of the public sector. I am working with Comprehensive Case Management and Employment Program data. I received past data provided by an outside evaluator, ICF, and data from 2022 that I then transformed to match the past data. This work was done mostly in Excel. I then used R to combine the files and moved into Tableau. The data I have been working with primarily is new enrollee participants in the program. I have been creating various visualizations in Tableau for several variables, mostly working with barriers to employment for participants variables. My favorite thing so far has been meeting many people in the data science field and bonding with my fellow interns over problem solving. The most challenging part of the internship has been learning Tableau as I go, though I have learned so much! I would definitely recommend the internship to anyone who wants to learn more about the data science field or wants hands on experience with data!